Dataset statistics
| Number of variables | 26 |
|---|---|
| Number of observations | 31465 |
| Missing cells | 106534 |
| Missing cells (%) | 13.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 6.0 MiB |
| Average record size in memory | 201.0 B |
Variable types
| NUM | 12 |
|---|---|
| CAT | 8 |
| DATE | 4 |
| BOOL | 1 |
| UNSUPPORTED | 1 |
Reproduction
| Analysis started | 2021-06-22 20:40:38.187247 |
|---|---|
| Analysis finished | 2021-06-22 20:41:11.329357 |
| Duration | 33.14 seconds |
| Version | pandas-profiling v2.8.0 |
| Command line | pandas_profiling --config_file config.yaml [YOUR_FILE.csv] |
| Download configuration | config.yaml |
Status has constant value "5" | Constant |
PurchaseOrderNumber has a high cardinality: 3806 distinct values | High cardinality |
AccountNumber has a high cardinality: 19119 distinct values | High cardinality |
CreditCardApprovalCode has a high cardinality: 30334 distinct values | High cardinality |
ShipToAddressID is highly correlated with BillToAddressID | High correlation |
BillToAddressID is highly correlated with ShipToAddressID | High correlation |
ShipMethodID is highly correlated with OnlineOrderFlag | High correlation |
OnlineOrderFlag is highly correlated with ShipMethodID | High correlation |
TaxAmt is highly correlated with SubTotal and 2 other fields | High correlation |
SubTotal is highly correlated with TaxAmt and 2 other fields | High correlation |
Freight is highly correlated with SubTotal and 2 other fields | High correlation |
TotalDue is highly correlated with SubTotal and 2 other fields | High correlation |
PurchaseOrderNumber has 27659 (87.9%) missing values | Missing |
SalesPersonID has 27659 (87.9%) missing values | Missing |
CreditCardID has 1131 (3.6%) missing values | Missing |
CreditCardApprovalCode has 1131 (3.6%) missing values | Missing |
CurrencyRateID has 17489 (55.6%) missing values | Missing |
Comment has 31465 (100.0%) missing values | Missing |
PurchaseOrderNumber is uniformly distributed | Uniform |
CreditCardApprovalCode is uniformly distributed | Uniform |
SalesOrderID has unique values | Unique |
SalesOrderNumber has unique values | Unique |
rowguid has unique values | Unique |
Comment is an unsupported type, check if it needs cleaning or further analysis | Unsupported |
| Distinct count | 31465 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 59391.0 |
|---|---|
| Minimum | 43659 |
| Maximum | 75123 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 43659 |
|---|---|
| 5-th percentile | 45232.2 |
| Q1 | 51525 |
| median | 59391 |
| Q3 | 67257 |
| 95-th percentile | 73549.8 |
| Maximum | 75123 |
| Range | 31464 |
| Interquartile range (IQR) | 15732 |
Descriptive statistics
| Standard deviation | 9083.307446 |
|---|---|
| Coefficient of variation (CV) | 0.1529408066 |
| Kurtosis | -1.2 |
| Mean | 59391 |
| Median Absolute Deviation (MAD) | 7866 |
| Skewness | 0 |
| Sum | 1868737815 |
| Variance | 82506474.17 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 67583 | 1 | < 0.1% | |
| 66858 | 1 | < 0.1% | |
| 75054 | 1 | < 0.1% | |
| 54576 | 1 | < 0.1% | |
| 56625 | 1 | < 0.1% | |
| 50482 | 1 | < 0.1% | |
| 52531 | 1 | < 0.1% | |
| 62772 | 1 | < 0.1% | |
| 64821 | 1 | < 0.1% | |
| 58678 | 1 | < 0.1% | |
| Other values (31455) | 31455 | > 99.9% |
| Value | Count | Frequency (%) | |
| 43659 | 1 | < 0.1% | |
| 43660 | 1 | < 0.1% | |
| 43661 | 1 | < 0.1% | |
| 43662 | 1 | < 0.1% | |
| 43663 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 75123 | 1 | < 0.1% | |
| 75122 | 1 | < 0.1% | |
| 75121 | 1 | < 0.1% | |
| 75120 | 1 | < 0.1% | |
| 75119 | 1 | < 0.1% |
RevisionNumber
Categorical
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| 8 | |
|---|---|
| 9 | 30 |
| Value | Count | Frequency (%) | |
| 8 | 31435 | 99.9% | |
| 9 | 30 | 0.1% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
OrderDate
Date
| Distinct count | 1124 |
|---|---|
| Unique (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| Minimum | 2011-05-31 00:00:00 |
|---|---|
| Maximum | 2014-06-30 00:00:00 |
Histogram
DueDate
Date
| Distinct count | 1124 |
|---|---|
| Unique (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| Minimum | 2011-06-12 00:00:00 |
|---|---|
| Maximum | 2014-07-12 00:00:00 |
Histogram
ShipDate
Date
| Distinct count | 1124 |
|---|---|
| Unique (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| Minimum | 2011-06-07 00:00:00 |
|---|---|
| Maximum | 2014-07-07 00:00:00 |
Histogram
| Distinct count | 1 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| 5 |
|---|
| Value | Count | Frequency (%) | |
| 5 | 31465 | 100.0% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 30.7 KiB |
| True | |
|---|---|
| False | 3806 |
| Value | Count | Frequency (%) | |
| True | 27659 | 87.9% | |
| False | 3806 | 12.1% |
| Distinct count | 31465 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| SO71273 | 1 |
|---|---|
| SO47468 | 1 |
| SO50116 | 1 |
| SO51643 | 1 |
| SO55293 | 1 |
| Other values (31460) |
| Value | Count | Frequency (%) | |
| SO71273 | 1 | < 0.1% | |
| SO47468 | 1 | < 0.1% | |
| SO50116 | 1 | < 0.1% | |
| SO51643 | 1 | < 0.1% | |
| SO55293 | 1 | < 0.1% | |
| SO59594 | 1 | < 0.1% | |
| SO46956 | 1 | < 0.1% | |
| SO48262 | 1 | < 0.1% | |
| SO71272 | 1 | < 0.1% | |
| SO67938 | 1 | < 0.1% | |
| Other values (31455) | 31455 | > 99.9% |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
| Distinct count | 3806 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 27659 |
| Missing (%) | 87.9% |
| Memory size | 245.8 KiB |
| PO8091154181 | 1 |
|---|---|
| PO9744171621 | 1 |
| PO20097117736 | 1 |
| PO18357170772 | 1 |
| PO19169155150 | 1 |
| Other values (3801) |
| Value | Count | Frequency (%) | |
| PO8091154181 | 1 | < 0.1% | |
| PO9744171621 | 1 | < 0.1% | |
| PO20097117736 | 1 | < 0.1% | |
| PO18357170772 | 1 | < 0.1% | |
| PO19169155150 | 1 | < 0.1% | |
| PO14848154975 | 1 | < 0.1% | |
| PO12093173799 | 1 | < 0.1% | |
| PO19256179500 | 1 | < 0.1% | |
| PO2842135731 | 1 | < 0.1% | |
| PO18183116686 | 1 | < 0.1% | |
| Other values (3796) | 3796 | 12.1% | |
| (Missing) | 27659 | 87.9% |
Length
| Max length | 13 |
|---|---|
| Median length | 3 |
| Mean length | 4.144700461 |
| Min length | 3 |
| Distinct count | 19119 |
|---|---|
| Unique (%) | 60.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| 10-4030-011176 | 28 |
|---|---|
| 10-4030-011091 | 28 |
| 10-4030-011331 | 27 |
| 10-4030-011262 | 27 |
| 10-4030-011330 | 27 |
| Other values (19114) |
| Value | Count | Frequency (%) | |
| 10-4030-011176 | 28 | 0.1% | |
| 10-4030-011091 | 28 | 0.1% | |
| 10-4030-011331 | 27 | 0.1% | |
| 10-4030-011262 | 27 | 0.1% | |
| 10-4030-011330 | 27 | 0.1% | |
| 10-4030-011277 | 27 | 0.1% | |
| 10-4030-011300 | 27 | 0.1% | |
| 10-4030-011287 | 27 | 0.1% | |
| 10-4030-011276 | 27 | 0.1% | |
| 10-4030-011200 | 27 | 0.1% | |
| Other values (19109) | 31193 | 99.1% |
Length
| Max length | 14 |
|---|---|
| Median length | 14 |
| Mean length | 14 |
| Min length | 14 |
CustomerID
Real number (ℝ≥0)
| Distinct count | 19119 |
|---|---|
| Unique (%) | 60.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20170.17568727157 |
|---|---|
| Minimum | 11000 |
| Maximum | 30118 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 11000 |
|---|---|
| 5-th percentile | 11492 |
| Q1 | 14432 |
| median | 19452 |
| Q3 | 25994 |
| 95-th percentile | 29844 |
| Maximum | 30118 |
| Range | 19118 |
| Interquartile range (IQR) | 11562 |
Descriptive statistics
| Standard deviation | 6261.72896 |
|---|---|
| Coefficient of variation (CV) | 0.310444939 |
| Kurtosis | -1.341699558 |
| Mean | 20170.17569 |
| Median Absolute Deviation (MAD) | 5583 |
| Skewness | 0.1802670394 |
| Sum | 634654578 |
| Variance | 39209249.57 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 11091 | 28 | 0.1% | |
| 11176 | 28 | 0.1% | |
| 11300 | 27 | 0.1% | |
| 11200 | 27 | 0.1% | |
| 11262 | 27 | 0.1% | |
| 11185 | 27 | 0.1% | |
| 11223 | 27 | 0.1% | |
| 11287 | 27 | 0.1% | |
| 11711 | 27 | 0.1% | |
| 11330 | 27 | 0.1% | |
| Other values (19109) | 31193 | 99.1% |
| Value | Count | Frequency (%) | |
| 11000 | 3 | < 0.1% | |
| 11001 | 3 | < 0.1% | |
| 11002 | 3 | < 0.1% | |
| 11003 | 3 | < 0.1% | |
| 11004 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 30118 | 8 | < 0.1% | |
| 30117 | 12 | < 0.1% | |
| 30116 | 4 | < 0.1% | |
| 30115 | 8 | < 0.1% | |
| 30114 | 8 | < 0.1% |
| Distinct count | 17 |
|---|---|
| Unique (%) | 0.4% |
| Missing | 27659 |
| Missing (%) | 87.9% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 280.6079873883342 |
|---|---|
| Minimum | 274.0 |
| Maximum | 290.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 274 |
|---|---|
| 5-th percentile | 275 |
| Q1 | 277 |
| median | 279 |
| Q3 | 284 |
| 95-th percentile | 289 |
| Maximum | 290 |
| Range | 16 |
| Interquartile range (IQR) | 7 |
Descriptive statistics
| Standard deviation | 4.846964646 |
|---|---|
| Coefficient of variation (CV) | 0.01727308154 |
| Kurtosis | -0.8639785694 |
| Mean | 280.6079874 |
| Median Absolute Deviation (MAD) | 3 |
| Skewness | 0.6426601181 |
| Sum | 1067994 |
| Variance | 23.49306628 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 277 | 473 | 1.5% | |
| 275 | 450 | 1.4% | |
| 279 | 429 | 1.4% | |
| 276 | 418 | 1.3% | |
| 289 | 348 | 1.1% | |
| 282 | 271 | 0.9% | |
| 281 | 242 | 0.8% | |
| 278 | 234 | 0.7% | |
| 283 | 189 | 0.6% | |
| 290 | 175 | 0.6% | |
| Other values (7) | 577 | 1.8% | |
| (Missing) | 27659 | 87.9% |
| Value | Count | Frequency (%) | |
| 274 | 48 | 0.2% | |
| 275 | 450 | 1.4% | |
| 276 | 418 | 1.3% | |
| 277 | 473 | 1.5% | |
| 278 | 234 | 0.7% |
| Value | Count | Frequency (%) | |
| 290 | 175 | 0.6% | |
| 289 | 348 | 1.1% | |
| 288 | 130 | 0.4% | |
| 287 | 39 | 0.1% | |
| 286 | 109 | 0.3% |
TerritoryID
Real number (ℝ≥0)
| Distinct count | 10 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 6.090767519466073 |
|---|---|
| Minimum | 1 |
| Maximum | 10 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 1 |
| Q1 | 4 |
| median | 6 |
| Q3 | 9 |
| 95-th percentile | 10 |
| Maximum | 10 |
| Range | 9 |
| Interquartile range (IQR) | 5 |
Descriptive statistics
| Standard deviation | 2.958119227 |
|---|---|
| Coefficient of variation (CV) | 0.4856726541 |
| Kurtosis | -1.083345417 |
| Mean | 6.090767519 |
| Median Absolute Deviation (MAD) | 2 |
| Skewness | -0.3904916518 |
| Sum | 191646 |
| Variance | 8.750469361 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 9 | 6843 | 21.7% | |
| 4 | 6224 | 19.8% | |
| 1 | 4594 | 14.6% | |
| 6 | 4067 | 12.9% | |
| 10 | 3219 | 10.2% | |
| 7 | 2672 | 8.5% | |
| 8 | 2623 | 8.3% | |
| 5 | 486 | 1.5% | |
| 3 | 385 | 1.2% | |
| 2 | 352 | 1.1% |
| Value | Count | Frequency (%) | |
| 1 | 4594 | 14.6% | |
| 2 | 352 | 1.1% | |
| 3 | 385 | 1.2% | |
| 4 | 6224 | 19.8% | |
| 5 | 486 | 1.5% |
| Value | Count | Frequency (%) | |
| 10 | 3219 | 10.2% | |
| 9 | 6843 | 21.7% | |
| 8 | 2623 | 8.3% | |
| 7 | 2672 | 8.5% | |
| 6 | 4067 | 12.9% |
| Distinct count | 19119 |
|---|---|
| Unique (%) | 60.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18263.154425552202 |
|---|---|
| Minimum | 405 |
| Maximum | 29883 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 405 |
|---|---|
| 5-th percentile | 698.2 |
| Q1 | 14080 |
| median | 19449 |
| Q3 | 24678 |
| 95-th percentile | 28863 |
| Maximum | 29883 |
| Range | 29478 |
| Interquartile range (IQR) | 10598 |
Descriptive statistics
| Standard deviation | 8210.069158 |
|---|---|
| Coefficient of variation (CV) | 0.449542777 |
| Kurtosis | -0.01743750554 |
| Mean | 18263.15443 |
| Median Absolute Deviation (MAD) | 5299 |
| Skewness | -0.8240474389 |
| Sum | 574650154 |
| Variance | 67405235.58 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 13550 | 28 | 0.1% | |
| 25073 | 28 | 0.1% | |
| 21596 | 27 | 0.1% | |
| 13890 | 27 | 0.1% | |
| 14444 | 27 | 0.1% | |
| 21639 | 27 | 0.1% | |
| 27756 | 27 | 0.1% | |
| 27048 | 27 | 0.1% | |
| 29638 | 27 | 0.1% | |
| 22168 | 27 | 0.1% | |
| Other values (19109) | 31193 | 99.1% |
| Value | Count | Frequency (%) | |
| 405 | 4 | < 0.1% | |
| 406 | 4 | < 0.1% | |
| 407 | 3 | < 0.1% | |
| 408 | 4 | < 0.1% | |
| 409 | 4 | < 0.1% |
| Value | Count | Frequency (%) | |
| 29883 | 1 | < 0.1% | |
| 29882 | 1 | < 0.1% | |
| 29881 | 1 | < 0.1% | |
| 29880 | 1 | < 0.1% | |
| 29879 | 1 | < 0.1% |
| Distinct count | 19119 |
|---|---|
| Unique (%) | 60.8% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 18249.192563165423 |
|---|---|
| Minimum | 9 |
| Maximum | 29883 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 9 |
|---|---|
| 5-th percentile | 687 |
| Q1 | 14063 |
| median | 19438 |
| Q3 | 24672 |
| 95-th percentile | 28859.8 |
| Maximum | 29883 |
| Range | 29874 |
| Interquartile range (IQR) | 10609 |
Descriptive statistics
| Standard deviation | 8218.429263 |
|---|---|
| Coefficient of variation (CV) | 0.4503448158 |
| Kurtosis | -0.02121916664 |
| Mean | 18249.19256 |
| Median Absolute Deviation (MAD) | 5305 |
| Skewness | -0.8231416425 |
| Sum | 574210844 |
| Variance | 67542579.55 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 13550 | 28 | 0.1% | |
| 25073 | 28 | 0.1% | |
| 29638 | 27 | 0.1% | |
| 13890 | 27 | 0.1% | |
| 14444 | 27 | 0.1% | |
| 25057 | 27 | 0.1% | |
| 12222 | 27 | 0.1% | |
| 22168 | 27 | 0.1% | |
| 24521 | 27 | 0.1% | |
| 27756 | 27 | 0.1% | |
| Other values (19109) | 31193 | 99.1% |
| Value | Count | Frequency (%) | |
| 9 | 8 | < 0.1% | |
| 11 | 1 | < 0.1% | |
| 12 | 2 | < 0.1% | |
| 13 | 1 | < 0.1% | |
| 15 | 1 | < 0.1% |
| Value | Count | Frequency (%) | |
| 29883 | 1 | < 0.1% | |
| 29882 | 1 | < 0.1% | |
| 29881 | 1 | < 0.1% | |
| 29880 | 1 | < 0.1% | |
| 29879 | 1 | < 0.1% |
| Distinct count | 2 |
|---|---|
| Unique (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| 1 | |
|---|---|
| 5 | 3806 |
| Value | Count | Frequency (%) | |
| 1 | 27659 | 87.9% | |
| 5 | 3806 | 12.1% |
Length
| Max length | 1 |
|---|---|
| Median length | 1 |
| Mean length | 1 |
| Min length | 1 |
| Distinct count | 18384 |
|---|---|
| Unique (%) | 60.6% |
| Missing | 1131 |
| Missing (%) | 3.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9684.100448341795 |
|---|---|
| Minimum | 1.0 |
| Maximum | 19237.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 983 |
| Q1 | 4894.25 |
| median | 9719.5 |
| Q3 | 14510.75 |
| 95-th percentile | 18323 |
| Maximum | 19237 |
| Range | 19236 |
| Interquartile range (IQR) | 9616.5 |
Descriptive statistics
| Standard deviation | 5566.299591 |
|---|---|
| Coefficient of variation (CV) | 0.5747874695 |
| Kurtosis | -1.20108221 |
| Mean | 9684.100448 |
| Median Absolute Deviation (MAD) | 4808.5 |
| Skewness | -0.009064604013 |
| Sum | 293757503 |
| Variance | 30983691.14 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 11843 | 28 | 0.1% | |
| 11334 | 28 | 0.1% | |
| 6169 | 27 | 0.1% | |
| 7336 | 27 | 0.1% | |
| 10261 | 27 | 0.1% | |
| 9006 | 27 | 0.1% | |
| 14162 | 27 | 0.1% | |
| 2233 | 27 | 0.1% | |
| 18822 | 27 | 0.1% | |
| 9387 | 27 | 0.1% | |
| Other values (18374) | 30062 | 95.5% | |
| (Missing) | 1131 | 3.6% |
| Value | Count | Frequency (%) | |
| 1 | 2 | < 0.1% | |
| 2 | 3 | < 0.1% | |
| 3 | 1 | < 0.1% | |
| 4 | 2 | < 0.1% | |
| 5 | 3 | < 0.1% |
| Value | Count | Frequency (%) | |
| 19237 | 1 | < 0.1% | |
| 19236 | 1 | < 0.1% | |
| 19235 | 2 | < 0.1% | |
| 19234 | 3 | < 0.1% | |
| 19233 | 1 | < 0.1% |
| Distinct count | 30334 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 1131 |
| Missing (%) | 3.6% |
| Memory size | 245.8 KiB |
| 743497Vi85247 | 1 |
|---|---|
| 57362Vi16259 | 1 |
| 1235631Vi67842 | 1 |
| 1225158Vi43093 | 1 |
| 731695Vi619 | 1 |
| Other values (30329) |
| Value | Count | Frequency (%) | |
| 743497Vi85247 | 1 | < 0.1% | |
| 57362Vi16259 | 1 | < 0.1% | |
| 1235631Vi67842 | 1 | < 0.1% | |
| 1225158Vi43093 | 1 | < 0.1% | |
| 731695Vi619 | 1 | < 0.1% | |
| 234884Vi24627 | 1 | < 0.1% | |
| 840648Vi24819 | 1 | < 0.1% | |
| 48008Vi75127 | 1 | < 0.1% | |
| 317373Vi76312 | 1 | < 0.1% | |
| 920339Vi42142 | 1 | < 0.1% | |
| Other values (30324) | 30324 | 96.4% | |
| (Missing) | 1131 | 3.6% |
Length
| Max length | 15 |
|---|---|
| Median length | 13 |
| Mean length | 12.65215319 |
| Min length | 3 |
| Distinct count | 2514 |
|---|---|
| Unique (%) | 18.0% |
| Missing | 17489 |
| Missing (%) | 55.6% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 9191.499570692617 |
|---|---|
| Minimum | 2.0 |
| Maximum | 12431.0 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 2 |
|---|---|
| 5-th percentile | 2226.5 |
| Q1 | 8510 |
| median | 10074 |
| Q3 | 11282 |
| 95-th percentile | 12208 |
| Maximum | 12431 |
| Range | 12429 |
| Interquartile range (IQR) | 2772 |
Descriptive statistics
| Standard deviation | 2945.170095 |
|---|---|
| Coefficient of variation (CV) | 0.3204232424 |
| Kurtosis | 1.168296897 |
| Mean | 9191.499571 |
| Median Absolute Deviation (MAD) | 1309 |
| Skewness | -1.38530835 |
| Sum | 128460398 |
| Variance | 8674026.891 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 9755 | 44 | 0.1% | |
| 12098 | 42 | 0.1% | |
| 8743 | 39 | 0.1% | |
| 11757 | 39 | 0.1% | |
| 10767 | 39 | 0.1% | |
| 11086 | 39 | 0.1% | |
| 10085 | 37 | 0.1% | |
| 9084 | 37 | 0.1% | |
| 11084 | 32 | 0.1% | |
| 4728 | 31 | 0.1% | |
| Other values (2504) | 13597 | 43.2% | |
| (Missing) | 17489 | 55.6% |
| Value | Count | Frequency (%) | |
| 2 | 1 | < 0.1% | |
| 4 | 8 | < 0.1% | |
| 8 | 1 | < 0.1% | |
| 15 | 3 | < 0.1% | |
| 28 | 2 | < 0.1% |
| Value | Count | Frequency (%) | |
| 12431 | 2 | < 0.1% | |
| 12428 | 9 | < 0.1% | |
| 12426 | 8 | < 0.1% | |
| 12420 | 9 | < 0.1% | |
| 12417 | 7 | < 0.1% |
| Distinct count | 4747 |
|---|---|
| Unique (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3491.0656730939136 |
|---|---|
| Minimum | 1.374 |
| Maximum | 163930.3943 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 1.374 |
|---|---|
| 5-th percentile | 8.99 |
| Q1 | 56.97 |
| median | 782.99 |
| Q3 | 2366.96 |
| 95-th percentile | 18060.72568 |
| Maximum | 163930.3943 |
| Range | 163929.0203 |
| Interquartile range (IQR) | 2309.99 |
Descriptive statistics
| Standard deviation | 11093.45254 |
|---|---|
| Coefficient of variation (CV) | 3.177669392 |
| Kurtosis | 40.40220951 |
| Mean | 3491.065673 |
| Median Absolute Deviation (MAD) | 755.71 |
| Skewness | 5.822374024 |
| Sum | 109846381.4 |
| Variance | 123064689.2 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 3578.27 | 1551 | 4.9% | |
| 2181.5625 | 758 | 2.4% | |
| 782.99 | 593 | 1.9% | |
| 39.98 | 578 | 1.8% | |
| 4.99 | 576 | 1.8% | |
| 2049.0982 | 554 | 1.8% | |
| 2443.35 | 543 | 1.7% | |
| 2071.4196 | 521 | 1.7% | |
| 7.28 | 359 | 1.1% | |
| 1000.4375 | 357 | 1.1% | |
| Other values (4737) | 25075 | 79.7% |
| Value | Count | Frequency (%) | |
| 1.374 | 1 | < 0.1% | |
| 2.29 | 139 | 0.4% | |
| 2.748 | 2 | < 0.1% | |
| 3.99 | 95 | 0.3% | |
| 4.99 | 576 | 1.8% |
| Value | Count | Frequency (%) | |
| 163930.3943 | 1 | < 0.1% | |
| 160378.3913 | 1 | < 0.1% | |
| 150837.4387 | 1 | < 0.1% | |
| 147390.9328 | 1 | < 0.1% | |
| 146154.5653 | 1 | < 0.1% |
| Distinct count | 4745 |
|---|---|
| Unique (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 323.7557432130939 |
|---|---|
| Minimum | 0.1099 |
| Maximum | 17948.5186 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 0.1099 |
|---|---|
| 5-th percentile | 0.7192 |
| Q1 | 4.5576 |
| median | 62.6392 |
| Q3 | 189.5976 |
| 95-th percentile | 1774.88626 |
| Maximum | 17948.5186 |
| Range | 17948.4087 |
| Interquartile range (IQR) | 185.04 |
Descriptive statistics
| Standard deviation | 1085.05418 |
|---|---|
| Coefficient of variation (CV) | 3.351459248 |
| Kurtosis | 42.1117139 |
| Mean | 323.7557432 |
| Median Absolute Deviation (MAD) | 60.6008 |
| Skewness | 5.908727871 |
| Sum | 10186974.46 |
| Variance | 1177342.573 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 286.2616 | 1551 | 4.9% | |
| 174.525 | 758 | 2.4% | |
| 62.6392 | 593 | 1.9% | |
| 3.1984 | 578 | 1.8% | |
| 0.3992 | 576 | 1.8% | |
| 163.9279 | 554 | 1.8% | |
| 195.468 | 543 | 1.7% | |
| 165.7136 | 521 | 1.7% | |
| 0.5824 | 359 | 1.1% | |
| 80.035 | 357 | 1.1% | |
| Other values (4735) | 25075 | 79.7% |
| Value | Count | Frequency (%) | |
| 0.1099 | 1 | < 0.1% | |
| 0.1832 | 139 | 0.4% | |
| 0.2198 | 2 | < 0.1% | |
| 0.3192 | 95 | 0.3% | |
| 0.3992 | 576 | 1.8% |
| Value | Count | Frequency (%) | |
| 17948.5186 | 1 | < 0.1% | |
| 16487.7988 | 1 | < 0.1% | |
| 14990.6516 | 1 | < 0.1% | |
| 14587.5413 | 1 | < 0.1% | |
| 14380.3298 | 1 | < 0.1% |
| Distinct count | 4744 |
|---|---|
| Unique (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 101.17369304941998 |
|---|---|
| Minimum | 0.0344 |
| Maximum | 5608.9121 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 0.0344 |
|---|---|
| 5-th percentile | 0.2248 |
| Q1 | 1.4243 |
| median | 19.5748 |
| Q3 | 59.2493 |
| 95-th percentile | 554.65196 |
| Maximum | 5608.9121 |
| Range | 5608.8777 |
| Interquartile range (IQR) | 57.825 |
Descriptive statistics
| Standard deviation | 339.0794267 |
|---|---|
| Coefficient of variation (CV) | 3.351458432 |
| Kurtosis | 42.11171484 |
| Mean | 101.173693 |
| Median Absolute Deviation (MAD) | 18.9378 |
| Skewness | 5.908727926 |
| Sum | 3183430.252 |
| Variance | 114974.8576 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 89.4568 | 1551 | 4.9% | |
| 54.5391 | 758 | 2.4% | |
| 19.5748 | 593 | 1.9% | |
| 0.9995 | 578 | 1.8% | |
| 0.1248 | 576 | 1.8% | |
| 51.2275 | 554 | 1.8% | |
| 61.0838 | 543 | 1.7% | |
| 51.7855 | 521 | 1.7% | |
| 0.182 | 359 | 1.1% | |
| 25.0109 | 357 | 1.1% | |
| Other values (4734) | 25075 | 79.7% |
| Value | Count | Frequency (%) | |
| 0.0344 | 1 | < 0.1% | |
| 0.0573 | 139 | 0.4% | |
| 0.0687 | 2 | < 0.1% | |
| 0.0998 | 95 | 0.3% | |
| 0.1248 | 576 | 1.8% |
| Value | Count | Frequency (%) | |
| 5608.9121 | 1 | < 0.1% | |
| 5152.4371 | 1 | < 0.1% | |
| 4684.5786 | 1 | < 0.1% | |
| 4558.6067 | 1 | < 0.1% | |
| 4493.8531 | 1 | < 0.1% |
| Distinct count | 4754 |
|---|---|
| Unique (%) | 15.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3915.9951093564277 |
|---|---|
| Minimum | 1.5183 |
| Maximum | 187487.825 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Memory size | 245.8 KiB |
Quantile statistics
| Minimum | 1.5183 |
|---|---|
| 5-th percentile | 9.934 |
| Q1 | 62.9519 |
| median | 865.204 |
| Q3 | 2615.4908 |
| 95-th percentile | 20430.54604 |
| Maximum | 187487.825 |
| Range | 187486.3067 |
| Interquartile range (IQR) | 2552.5389 |
Descriptive statistics
| Standard deviation | 12515.46271 |
|---|---|
| Coefficient of variation (CV) | 3.195985277 |
| Kurtosis | 40.56428029 |
| Mean | 3915.995109 |
| Median Absolute Deviation (MAD) | 835.0596 |
| Skewness | 5.830758838 |
| Sum | 123216786.1 |
| Variance | 156636806.9 |
Histogram with fixed size bins (bins=10)
| Value | Count | Frequency (%) | |
| 3953.9884 | 1551 | 4.9% | |
| 2410.6266 | 758 | 2.4% | |
| 865.204 | 593 | 1.9% | |
| 44.1779 | 578 | 1.8% | |
| 5.514 | 576 | 1.8% | |
| 2264.2536 | 554 | 1.8% | |
| 2699.9018 | 543 | 1.7% | |
| 2288.9187 | 521 | 1.7% | |
| 8.0444 | 359 | 1.1% | |
| 1105.4834 | 357 | 1.1% | |
| Other values (4744) | 25075 | 79.7% |
| Value | Count | Frequency (%) | |
| 1.5183 | 1 | < 0.1% | |
| 2.5305 | 139 | 0.4% | |
| 3.0365 | 2 | < 0.1% | |
| 4.409 | 95 | 0.3% | |
| 5.514 | 576 | 1.8% |
| Value | Count | Frequency (%) | |
| 187487.825 | 1 | < 0.1% | |
| 182018.6272 | 1 | < 0.1% | |
| 170512.6689 | 1 | < 0.1% | |
| 166537.0808 | 1 | < 0.1% | |
| 165028.7482 | 1 | < 0.1% |
| Distinct count | 31465 |
|---|---|
| Unique (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| F34A07B0-6E8C-474B-A2E0-12515653DC26 | 1 |
|---|---|
| DC158DF8-916A-4922-A691-3F41A3E8A371 | 1 |
| B6CFD848-1E5C-42E7-BEAA-00592F76ECF8 | 1 |
| 9E875A7E-1A63-4E29-9E31-C67B9C5E0ECD | 1 |
| 191DC789-FEF7-4F70-B938-F5A5CD7968D3 | 1 |
| Other values (31460) |
| Value | Count | Frequency (%) | |
| F34A07B0-6E8C-474B-A2E0-12515653DC26 | 1 | < 0.1% | |
| DC158DF8-916A-4922-A691-3F41A3E8A371 | 1 | < 0.1% | |
| B6CFD848-1E5C-42E7-BEAA-00592F76ECF8 | 1 | < 0.1% | |
| 9E875A7E-1A63-4E29-9E31-C67B9C5E0ECD | 1 | < 0.1% | |
| 191DC789-FEF7-4F70-B938-F5A5CD7968D3 | 1 | < 0.1% | |
| 4FFF56E8-6B0D-4FD3-8E47-672988B8AB2B | 1 | < 0.1% | |
| A68AF604-C054-406C-A074-60CEA00E3E61 | 1 | < 0.1% | |
| 1A7A7B30-EA59-4CE8-A85E-AC6114E5DE1E | 1 | < 0.1% | |
| C9F72640-443B-419E-AB41-4F5C47B2DEAC | 1 | < 0.1% | |
| 0518E6FC-D0A4-4CAA-B9D1-A968580A665C | 1 | < 0.1% | |
| Other values (31455) | 31455 | > 99.9% |
Length
| Max length | 36 |
|---|---|
| Median length | 36 |
| Mean length | 36 |
| Min length | 36 |
ModifiedDate
Date
| Distinct count | 1124 |
|---|---|
| Unique (%) | 3.6% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 245.8 KiB |
| Minimum | 2011-06-07 00:00:00 |
|---|---|
| Maximum | 2014-07-07 00:00:00 |
Histogram
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.Cramér's V (φc)
Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.First rows
| SalesOrderID | RevisionNumber | OrderDate | DueDate | ShipDate | Status | OnlineOrderFlag | SalesOrderNumber | PurchaseOrderNumber | AccountNumber | CustomerID | SalesPersonID | TerritoryID | BillToAddressID | ShipToAddressID | ShipMethodID | CreditCardID | CreditCardApprovalCode | CurrencyRateID | SubTotal | TaxAmt | Freight | TotalDue | Comment | rowguid | ModifiedDate | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | 43659 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43659 | PO522145787 | 10-4020-000676 | 29825 | 279.0 | 5 | 985 | 985 | 5 | 16281.0 | 105041Vi84182 | NaN | 20565.6206 | 1971.5149 | 616.0984 | 23153.2339 | NaN | 79B65321-39CA-4115-9CBA-8FE0903E12E6 | 2011-06-07 |
| 1 | 43660 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43660 | PO18850127500 | 10-4020-000117 | 29672 | 279.0 | 5 | 921 | 921 | 5 | 5618.0 | 115213Vi29411 | NaN | 1294.2529 | 124.2483 | 38.8276 | 1457.3288 | NaN | 738DC42D-D03B-48A1-9822-F95A67EA7389 | 2011-06-07 |
| 2 | 43661 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43661 | PO18473189620 | 10-4020-000442 | 29734 | 282.0 | 6 | 517 | 517 | 5 | 1346.0 | 85274Vi6854 | 4.0 | 32726.4786 | 3153.7696 | 985.5530 | 36865.8012 | NaN | D91B9131-18A4-4A11-BC3A-90B6F53E9D74 | 2011-06-07 |
| 3 | 43662 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43662 | PO18444174044 | 10-4020-000227 | 29994 | 282.0 | 6 | 482 | 482 | 5 | 10456.0 | 125295Vi53935 | 4.0 | 28832.5289 | 2775.1646 | 867.2389 | 32474.9324 | NaN | 4A1ECFC0-CC3A-4740-B028-1C50BB48711C | 2011-06-07 |
| 4 | 43663 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43663 | PO18009186470 | 10-4020-000510 | 29565 | 276.0 | 4 | 1073 | 1073 | 5 | 4322.0 | 45303Vi22691 | NaN | 419.4589 | 40.2681 | 12.5838 | 472.3108 | NaN | 9B1E7A40-6AE0-4AD3-811C-A64951857C4B | 2011-06-07 |
| 5 | 43664 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43664 | PO16617121983 | 10-4020-000397 | 29898 | 280.0 | 1 | 876 | 876 | 5 | 806.0 | 95555Vi4081 | NaN | 24432.6088 | 2344.9921 | 732.8100 | 27510.4109 | NaN | 22A8A5DA-8C22-42AD-9241-839489B6EF0D | 2011-06-07 |
| 6 | 43665 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43665 | PO16588191572 | 10-4020-000146 | 29580 | 283.0 | 1 | 849 | 849 | 5 | 15232.0 | 35568Vi78804 | NaN | 14352.7713 | 1375.9427 | 429.9821 | 16158.6961 | NaN | 5602C304-853C-43D7-9E79-76E320D476CF | 2011-06-07 |
| 7 | 43666 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43666 | PO16008173883 | 10-4020-000511 | 30052 | 276.0 | 4 | 1074 | 1074 | 5 | 13349.0 | 105623Vi69217 | NaN | 5056.4896 | 486.3747 | 151.9921 | 5694.8564 | NaN | E2A90057-1366-4487-8A7E-8085845FF770 | 2011-06-07 |
| 8 | 43667 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43667 | PO15428132599 | 10-4020-000646 | 29974 | 277.0 | 3 | 629 | 629 | 5 | 10370.0 | 55680Vi53503 | NaN | 6107.0820 | 586.1203 | 183.1626 | 6876.3649 | NaN | 86D5237D-432D-4B21-8ABC-671942F5789D | 2011-06-07 |
| 9 | 43668 | 8 | 2011-05-31 | 2011-06-12 | 2011-06-07 | 5 | False | SO43668 | PO14732180295 | 10-4020-000514 | 29614 | 282.0 | 6 | 529 | 529 | 5 | 1566.0 | 85817Vi8045 | 4.0 | 35944.1562 | 3461.7654 | 1081.8017 | 40487.7233 | NaN | 281CC355-D538-494E-9B44-461B36A826C6 | 2011-06-07 |
Last rows
| SalesOrderID | RevisionNumber | OrderDate | DueDate | ShipDate | Status | OnlineOrderFlag | SalesOrderNumber | PurchaseOrderNumber | AccountNumber | CustomerID | SalesPersonID | TerritoryID | BillToAddressID | ShipToAddressID | ShipMethodID | CreditCardID | CreditCardApprovalCode | CurrencyRateID | SubTotal | TaxAmt | Freight | TotalDue | Comment | rowguid | ModifiedDate | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 31455 | 75114 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75114 | NaN | 10-4030-024704 | 24704 | NaN | 8 | 24932 | 24932 | 1 | 4318.0 | 227542Vi22680 | NaN | 21.49 | 1.7192 | 0.5373 | 23.7465 | NaN | 1BE20D6F-497C-4D6A-97ED-BFFEA6310E15 | 2014-07-07 |
| 31456 | 75115 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75115 | NaN | 10-4030-026832 | 26832 | NaN | 8 | 13618 | 13618 | 1 | 4360.0 | 327761Vi22867 | NaN | 80.47 | 6.4376 | 2.0118 | 88.9194 | NaN | 7883FF0C-9E63-4AA3-9B08-342476B19A0D | 2014-07-07 |
| 31457 | 75116 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75116 | NaN | 10-4030-016402 | 16402 | NaN | 10 | 27392 | 27392 | 1 | 15564.0 | 728746Vi80423 | NaN | 4.99 | 0.3992 | 0.1248 | 5.5140 | NaN | 0B91256B-5206-4B0C-86DE-FE37E394798E | 2014-07-07 |
| 31458 | 75117 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75117 | NaN | 10-4030-018178 | 18178 | NaN | 10 | 25522 | 25522 | 1 | 18150.0 | 928953Vi94119 | NaN | 29.48 | 2.3584 | 0.7370 | 32.5754 | NaN | 90A7DC3B-0848-4EE4-9110-8EBC46A2DEF0 | 2014-07-07 |
| 31459 | 75118 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75118 | NaN | 10-4030-013671 | 13671 | NaN | 8 | 27439 | 27439 | 1 | 10513.0 | 828969Vi54175 | NaN | 135.23 | 10.8184 | 3.3808 | 149.4292 | NaN | FDE750F5-95C9-4D63-AADC-807940A0FAFA | 2014-07-07 |
| 31460 | 75119 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75119 | NaN | 10-4030-011981 | 11981 | NaN | 1 | 17649 | 17649 | 1 | 6761.0 | 429826Vi35166 | NaN | 42.28 | 3.3824 | 1.0570 | 46.7194 | NaN | 9382F1C9-383A-435F-9449-0EECEA21B78D | 2014-07-07 |
| 31461 | 75120 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75120 | NaN | 10-4030-018749 | 18749 | NaN | 6 | 28374 | 28374 | 1 | 8925.0 | 929849Vi46003 | NaN | 84.96 | 6.7968 | 2.1240 | 93.8808 | NaN | AE6A4FCF-FF73-4CD4-AF2C-5993D00D4AFE | 2014-07-07 |
| 31462 | 75121 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75121 | NaN | 10-4030-015251 | 15251 | NaN | 6 | 26553 | 26553 | 1 | 14220.0 | 529864Vi73738 | NaN | 74.98 | 5.9984 | 1.8745 | 82.8529 | NaN | D7395C0E-00CB-4BFA-A238-0D6A9F49884F | 2014-07-07 |
| 31463 | 75122 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75122 | NaN | 10-4030-015868 | 15868 | NaN | 6 | 14616 | 14616 | 1 | 18719.0 | 330022Vi97312 | NaN | 30.97 | 2.4776 | 0.7743 | 34.2219 | NaN | 4221035A-4159-492F-AF40-4363A64FFC16 | 2014-07-07 |
| 31464 | 75123 | 8 | 2014-06-30 | 2014-07-12 | 2014-07-07 | 5 | True | SO75123 | NaN | 10-4030-018759 | 18759 | NaN | 6 | 14024 | 14024 | 1 | 10084.0 | 230370Vi51970 | NaN | 189.97 | 15.1976 | 4.7493 | 209.9169 | NaN | D54752FF-2B54-4BE5-95EA-3B72289C059F | 2014-07-07 |